@echo off

echo Creating TenantDataStore...
call osql -S LitwareHR -E -i "sql\DataStore_CreateTenantDataStore.sql"
call osql -S LitwareHR -E -i "sql\DataStore_AddTrustedSubsystemAccount.sql

echo Creating TenantMetadataStore...
call osql -S LitwareHR -E -i "sql\MetadataStore_CreateTenantMetadataStore.sql"
call osql -S LitwareHR -E -i "sql\MetadataStore_AddTrustedSubsystemAccount.sql"
call osql -S LitwareHR -E -i "sql\MetadataStore_InsertTenantMetadataStore.sql

echo Creating WorkflowDataStore...
call osql -S LitwareHR -E -i "sql\WorkflowStore_CreateTrackingStore.sql"
call osql -S LitwareHR -E -i "sql\WorkflowStore_CreatePersistenceStore.sql"
call osql -S LitwareHR -E -i "sql\WorkflowStore_AddTrustedSubsystemAccount.sql"

echo Creating offline sitka database...
call osql -S LitwareHR -E -i "sql\SitkaOffline_CreateDatabase.sql"
call osql -S LitwareHR -E -i "sql\SitkaOffline_CreateTables.sql